<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %><%--
  Created by IntelliJ IDEA.
  User: 1
  Date: 2018/5/3
  Time: 16:26
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <jsp:include page="header.jsp"/>
    <style type="text/css">
        table{border-collapse: collapse;}
        td{
            boder:1px  solid  #000;
            padding:10px;
        }
    </style>
    <table>
        <tr>
            <td>编号</td>
            <td>用户名</td>
            <td>密码</td>
            <td>操作1</td>
            <td>操作2</td>
        </tr>
        <%
        Connection connection=null;
            Statement statement=null;
            ResultSet resultSet=null;
            String sql="select * from t_users";
            Class.forName("com.mysql.jdbc.Driver");
            connection= DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                    "root",
                    "123456"
            );
            statement=connection.createStatement();
            resultSet=statement.executeQuery(sql);
            class User{
                int id;
                String username;
                String password;
            }
            List<User> userList=new ArrayList<User>();
            while(resultSet.next())
            {
                int id = resultSet.getInt(1);
                String username = resultSet.getString(2);
                String password = resultSet.getString(3);

                User user = new User();
                user.id = id;
                user.username = username;
                user.password = password;

                userList.add(user);

        }
            resultSet.close();;
            statement.close();
            connection.close();

            for (User u : userList) {


                out.write("<tr><td>" +u.id +
                        "</td><td>" + u.username +
                        "</td><td>" + u.password +
                        "</td><td>" +
                        "<a href='userDelete.jsp?id="
                        +u.id+"'>删除</a></td>" +
                        "<td><a href='userEdit.jsp?id="+u.id+"&username="+u.username+"&password="+u.password+"'>更新</a></td></tr>");
            }
        %>


    </table>

</body>
</html>
